<?php
    /* Connecting, selecting database */

    $link = mysql_connect("localhost", "root", "")
	or die("Could not connect : " . mysql_error());

    print "Connected successfully<br />";

    mysql_select_db("PACTS") or die("Could not select database");

    /* Performing SQL query */
    $query = "UPDATE `Family` SET `FamilyShortName` = UCASE(`FamilyShortName`);";

    $result = mysql_query($query) or die("Query failed : " . mysql_error());
	if( $result == 1) {

	    print "Updated Sucessfully<br />";

	}
    /* Free resultset */
    //mysql_free_result($result);

    /* Closing connection */
    mysql_close($link);
?>


